﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using Frame.Lib.Core.Base;

namespace Jzy.DAL.Project
{
    public class TaskChangeDAL:BaseDAL
    {
        public int GetChangeCount(string taskID)
        {
            string sql = "select count(*) from " + OTableName.PrjTaskChange  + " where TaskID = " + taskID;
            int count = dbOper.GetScalar<int>(sql);
            return count;
        }

        public DataTable GetList(string TaskID)
        {
            string sql = "select * from " + OTableName.PrjTaskChange + " where TaskID=" + TaskID + " order by InputTime desc";
            DataTable dt = dbOper.Query(sql);
            return dt;
        }
    }
}
